{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Exercise Basic Details","Paperwork and Execution","Detail Planning","Budget","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Exercise Basic Details","index":0,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[15,1,16,1],[36,2,36,4],[37,2,37,4],[41,2,41,4],[39,2,39,4],[18,2,18,4],[20,1,32,1],[24,2,25,2],[22,2,23,2],[20,2,21,2],[30,2,32,2],[27,2,28,2],[1,2,1,4],[9,2,9,4],[16,3,16,4],[15,3,15,4],[13,2,13,4],[11,2,11,4],[7,2,7,4]]}
[]
[null,"Activity Name",null,null,null,null,"Date Created",null,null,"Created By"]
[]
[null,"Start Date",null,"Time"]
[null,"End Date",null,"Time"]
[]
[]
[null,"Organising Squadron"]
[]
[null,"Other Squadrons"]
[]
[null,"Activity Purpose"]
[]
[null,"Activity Main location"]
[]
[null,"Cadet Numbers","Male"]
[null,null,"Female"]
[]
[null,"Activity Commander"]
[]
[null,"Staff Numbers","Officers","Male"]
[null,null,null,"Female"]
[null,null,"SNCO","Male"]
[null,null,null,"Female"]
[null,null,"CI's","Male"]
[null,null,null,"Female"]
[]
[null,null,"Total","Male",{"$f":"SUM(E25,E23,E21)","v":0}]
[null,null,null,"Female",{"$f":"SUM(E26,E24,E22)","v":0}]
[]
[null,null,"Ratios","Total",{"$f":"SUM(D16:E17)/SUM(E28:E29)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Male",{"$f":"D16/E28","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Female",{"$f":"D17/E29","v":{"$error":"#DIV/0!"}}]
[]
[null,"Initial Plan Approval"]
[]
[null,"Name"]
[null,"Rank"]
[]
[null,"Approved"]
[]
[null,"Date"]
[]
[null,"Authorisation Code"]

{"sheet":"Paperwork and Execution","index":1,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[60,1,60,3],[61,1,61,3],[63,1,63,3],[65,1,65,3],[0,0,0,7],[47,0,47,4],[46,0,46,4],[45,0,45,4],[44,0,44,4],[43,0,43,4],[10,0,10,4],[37,0,37,4],[36,0,36,4],[35,0,35,4],[55,0,55,4],[54,0,54,4],[53,0,53,4],[52,0,52,4],[51,0,51,4],[50,0,50,4],[49,0,49,4],[5,0,5,4],[4,0,4,4],[31,0,31,4],[30,0,30,4],[29,0,29,4],[28,0,28,4],[24,0,24,4],[23,0,23,4],[22,0,22,4],[18,0,18,4],[38,0,38,4],[48,0,48,4],[12,0,12,4],[11,0,11,4],[6,0,6,4],[17,0,17,4],[16,0,16,4]]}
["Execution"]
[]
["Staff"]
[]
["Staff notice published",null,null,null,null,"No"]
["Staff availibility and list produced",null,null,null,null,"No"]
["Staff ratios checked",null,null,null,null,"No"]
[]
["Cadets"]
[]
["Sqn event sign up sheet published",null,null,null,null,"No"]
["Other sqn invite letter completed and approved",null,null,null,null,"No"]
["Other sqn invite letter sent",null,null,null,null,"No"]
[]
["Transport"]
[]
["Vehicles Booked",null,null,null,null,"No"]
["Cadets and Staff Assigned to Vehicles",null,null,null,null,"No"]
["Drivers Identified",null,null,null,null,"No"]
[]
["Accomodation"]
[]
["Rooms Booked and Confirmed",null,null,null,null,"No"]
["Tents checked and assigned",null,null,null,null,"No"]
["Room/Tent arrangement",null,null,null,null,"No"]
[]
["Food"]
[]
["Dietry Requirements Confirmed",null,null,null,null,"No"]
["Meals booked",null,null,null,null,"No"]
["Chef and assistant confirmed",null,null,null,null,"No"]
["Food purchase arranged",null,null,null,null,"No"]
[]
["Activities"]
[]
["Venues booked and confirmed",null,null,null,null,"No"]
["Equipment list completed",null,null,null,null,"No"]
["Equipment availibility confirmed",null,null,null,null,"No"]
["Final Program completed and approved",null,null,null,null,"No"]
[]
[]
["Paperwork"]
[]
["RA completed and signed",null,null,null,null,"No"]
["Wing approval sent",null,null,null,null,"No"]
["Wing Approval received",null,null,null,null,"No"]
["Land clearance sent",null,null,null,null,"No"]
["Land clearance obtained",null,null,null,null,"No"]
["Brief sheet completed and approved",null,null,null,null,"No"]
["Brief sheet issued",null,null,null,null,"No"]
["RASP completed and signed",null,null,null,null,"No"]
["EASP completed and approved",null,null,null,null,"No"]
["Travel management plan",null,null,null,null,"No"]
["Weapon authorisation sent",null,null,null,null,"No"]
["ACF13/ACP17's issued",null,null,null,null,"No"]
["ACF13/ACP17's returned and checked",null,null,null,null,"No"]
[]
[]
["Final Approval"]
[]
["Name"]
["Rank"]
[]
["Approved"]
[]
["Date"]

{"sheet":"Detail Planning","index":2,"n_rows":106,"n_cols":9,"rows_kept":106,"cut":false,"hidden":false,"merged":[[101,2,101,4],[103,2,103,4],[105,2,105,4],[93,1,93,2],[91,1,91,2],[61,1,61,3],[26,1,26,3],[100,2,100,4],[44,1,44,3],[45,1,45,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[60,1,60,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[38,1,38,3],[39,1,39,3],[4,9,17,16],[61,4,61,6],[60,4,60,6],[56,9,61,16],[25,4,25,5],[22,9,26,16],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[37,1,37,3],[12,1,12,3],[11,1,11,3],[10,1,10,3],[14,1,14,3],[16,1,16,3],[15,1,15,3],[23,1,23,3],[25,1,25,3],[32,1,32,3],[34,1,34,3],[36,1,36,3],[4,1,4,3],[8,1,8,3],[7,1,7,3],[6,1,6,3],[85,2,85,16],[84,2,84,16],[83,2,83,16],[82,2,82,16],[81,2,81,16],[80,2,80,16],[79,2,79,16],[78,2,78,16],[77,2,77,16],[76,2,76,16],[75,2,75,16],[74,2,74,16],[68,2,68,16],[73,2,73,16],[72,2,72,16],[71,2,71,16],[70,2,70,16],[69,2,69,16]]}
[]
[]
[null,"Transport"]
[]
[null,"Number of Cadets and Staff",null,null,{"$f":"SUM('Exercise Basic Details'!D16:E17)+SUM('Exercise Basic Details'!E28:E29)","v":0},null,null,null,"Notes:"]
[]
[null,"Coach Required",null,null,"No"]
[null,"Size of Coach"]
[null,"Number of Coaches Required",null,null,{"$f":" ROUNDUP(((E5-(E16*E17))/E8),0)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Minibus required",null,null,"No"]
[null,"Size of Minibus"]
[null,"Number of Minibuses Required",null,null,{"$f":"IF(E11=\"Yes\",ROUNDUP(((E5-(E16*E17))/E12),0),0)","v":0}]
[]
[null,"Cars Used",null,null,"No"]
[null,"Number of Cars"]
[null,"Number of passengers"]
[]
[]
[]
[]
[null,"Accomodation"]
[null,null,null,null,null,null,null,null,"Notes:"]
[null,"Number of Cadets and Staff",null,null,{"$f":"SUM('Exercise Basic Details'!D16:E17)+SUM('Exercise Basic Details'!E28:E29)","v":0}]
[]
[null,"Cadet Accomodation style"]
[null,"Number of Rooms Req'd"]
[]
[]
[]
[null,"Food"]
[]
[null,"Number of Cadets and Staff",null,null,{"$f":"SUM('Exercise Basic Details'!D16:E17)+SUM('Exercise Basic Details'!E28:E29)","v":0}]
[]
[null,"Length of Activity",null,null,{"$f":"('Exercise Basic Details'!C5-'Exercise Basic Details'!C4)+1","v":1}]
[]
[null,"Breakfast Day 1",null,null,"No"]
[null,"Lunch Day 1",null,null,"No"]
[null,"Evening Meal Day 1",null,null,"No"]
[null,"Breakfast Day 2",null,null,"No"]
[null,"Lunch Day 2",null,null,"No"]
[null,"Evening Meal Day 2",null,null,"No"]
[null,"Breakfast Day 3",null,null,"No"]
[null,"Lunch Day 3",null,null,"No"]
[null,"Evening Meal Day 3",null,null,"No"]
[null,"Breakfast Day 4",null,null,"No"]
[null,"Lunch Day 4",null,null,"No"]
[null,"Evening Meal Day 4",null,null,"No"]
[null,"Breakfast Day 5",null,null,"No"]
[null,"Lunch Day 5",null,null,"No"]
[null,"Evening Meal Day 5",null,null,"No"]
[null,"Breakfast Day 6",null,null,"No"]
[null,"Lunch Day 6",null,null,"No"]
[null,"Evening Meal Day 6",null,null,"No"]
[]
[]
[null,"Number of Breakfasts Required",null,null,{"$f":"(COUNTIF(E37,\"Yes\")+COUNTIF(E40,\"Yes\")+COUNTIF(E43,\"Yes\")+COUNTIF(E46,\"Yes\")+COUNTIF(E49,\"Yes\")+COUNTIF(E52,\"Yes\"))*E33","v":0},null,null,null,"Notes:"]
[null,"Number of Lunches Required",null,null,{"$f":"(COUNTIF(E38,\"Yes\")+COUNTIF(E41,\"Yes\")+COUNTIF(E44,\"Yes\")+COUNTIF(E47,\"Yes\")+COUNTIF(E50,\"Yes\")+COUNTIF(E53,\"Yes\"))*E33","v":0}]
[null,"Number of Evening Meals",null,null,{"$f":"(COUNTIF(E39,\"Yes\")+COUNTIF(E42,\"Yes\")+COUNTIF(E45,\"Yes\")+COUNTIF(E48,\"Yes\")+COUNTIF(E51,\"Yes\")+COUNTIF(E54,\"Yes\"))*E33","v":0}]
[]
[null,"Method of suppling Meals"]
[null,"Method of suppling Meals"]
[]
[]
[]
[]
[null,"Activity"]
[]
[null,"Day 1 am"]
[null,"Day 1 pm"]
[null,"Day 1 ev"]
[null,"Day 2 am"]
[null,"Day 2 pm"]
[null,"Day 2 ev"]
[null,"Day 3 am"]
[null,"Day 3 pm"]
[null,"Day 3 ev"]
[null,"Day 4 am"]
[null,"Day 4 pm"]
[null,"Day 4 ev"]
[null,"Day 5 am"]
[null,"Day 5 pm"]
[null,"Day 5 ev"]
[null,"Day 6 am"]
[null,"Day 6 pm"]
[null,"Day 6 ev"]
[]
[]
[]
[null,"Budgeting"]
[]
[null,"Buffer %",null,{"$f":"Budget!M5/100","v":0.1}]
[]
[null,"Cost Per Attendee",null,{"$f":"Budget!M6","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,"Plan Approval"]
[]
[null,"Name"]
[null,"Rank"]
[]
[null,"Approved"]
[]
[null,"Date"]

{"sheet":"Budget","index":3,"n_rows":119,"n_cols":13,"rows_kept":119,"cut":false,"hidden":false,"merged":[[78,1,83,8],[91,2,92,4],[96,2,97,4],[101,2,102,4],[106,2,107,4]]}
[]
["Event date",null,{"$f":"'Exercise Basic Details'!C4","v":"00:00:00"},"to",{"$f":"'Exercise Basic Details'!C5","v":"00:00:00"},null,null,"Number of days",null,null,{"$f":"'Detail Planning'!E35","v":1}]
["Location",null,{"$f":"'Exercise Basic Details'!C14:E14","v":0},null,null,null,null,"Number of cadets",null,null,{"$f":"'Detail Planning'!E24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Buffer %"]
[null,null,null,null,null,null,null,"Total cost",null,null,{"$f":"K15+K31+K43+K53+K71+K86+K94+K99+K104+K109-(K115+K117+K119)","v":0},null,10]
[null,null,null,null,null,null,null,"Cost Per Cadet",null,null,{"$f":"K5/K3","v":{"$error":"#DIV/0!"}},null,{"$f":"(((K5/100)*M5)+K5)/K3","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Messing"]
[]
[null,"Total Messing cost"]
[]
[null,"Messing Cost per cadets per Day"]
[]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"(K3*K2*K13)+K11","v":0}]
[]
[]
[]
[null,"Transport"]
[]
[null,"Number of Vehicles",null,null,null,null,null,null,null,null,{"$f":"'Detail Planning'!E13+'Detail Planning'!E16","v":0}]
[]
[null,"Diesel Cost (per litre)"]
[]
[null,"Return Journey millage"]
[]
[null,"Extra Millage"]
[]
[null,"Coach Transport"]
[]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"((((K21*(K25+K27))/30)*4.456)*K23)+K29","v":0}]
[]
[]
[]
[null,"Accomodation"]
[]
[null,"Cost Per room"]
[]
[null,"Number of rooms",null,null,null,null,null,null,null,null,{"$f":"'Detail Planning'!E27","v":0}]
[]
[null,"Total Cost"]
[]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"((K37*K2)*K39)+K41","v":0}]
[]
[]
[]
[null,"Facilities"]
[]
[null,"Classrooms"]
[]
[null,"Adventure training"]
[]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K49+K51","v":0}]
[]
[]
[]
[null,"Equipment"]
[]
[null,"DofE",null,null,null,null,null,0,null,null,{"$f":"K3*H59","v":0}]
[]
[null,"Adventure Training",null,null,null,null,null,0,null,null,{"$f":"K3*H61","v":0}]
[]
[null,"Shooting",null,null,null,null,null,0,null,null,{"$f":"K3*H63","v":0}]
[]
[null,"Teaching",null,null,null,null,null,0,null,null,{"$f":"K3*H65","v":0}]
[]
[null,"Sports",null,null,null,null,null,0,null,null,{"$f":"K3*H67","v":0}]
[]
[null,"Other",null,null,null,null,null,0,null,null,{"$f":"K3*H69","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K59+K61+K63+K65+K67","v":0}]
[]
[]
[]
[null,"Misc"]
[]
[null,"Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total"]
[]
[]
[]
[null,"Evening Actvities"]
[]
[null,"Event","Swimming",null,null,null,null,null,"Total Cost"]
[null,null,null,null,null,null,null,null,"Cost Per cadet"]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K92+(K93*K3)","v":0}]
[]
[]
[null,"Event",null,null,null,null,null,null,"Total Cost"]
[null,null,null,null,null,null,null,null,"Cost Per cadet"]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K97+(K98*K8)","v":0}]
[]
[]
[null,"Event",null,null,null,null,null,null,"Total Cost"]
[null,null,null,null,null,null,null,null,"Cost Per cadet"]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K102+(K103*K13)","v":0}]
[]
[]
[null,"Event",null,null,null,null,null,null,"Total Cost"]
[null,null,null,null,null,null,null,null,"Cost Per cadet"]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K107+(K108*K18)","v":0}]
[]
[]
[]
[null,"Additional Funding"]
[]
[null,"Squadron Civilian Commitee"]
[]
[null,"Wing Civilian Commitee"]
[]
[null,"Other Sources"]

{"sheet":"Sheet3","index":4,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Yes","Barrack Block","RAF/Army/Navy Facilities",0.02,"Yes"]
["No","Huts","Camp Staff Cooking",0.05,"No"]
[null,"Small Tents(3man)","Cadet Self Cooking",0.1,"N/A"]
[null,"Large Tents(12x12)","No Meals Required",0.15]
[null,"None",null,0.2]